janema
Board Regular
- Joined
- Nov 28, 2022
- Messages
- 132
- Office Version
- 365
- 2021
- 2019
- 2011
- 2010
- Platform
- Windows
- Mobile
I am having issues with figuring out the right way to write this formula. I am trying to get the formula to multiply the total in cell H4 (which is a currently an XLOOKUP formula) by the value in H2 if G4 equals "A4H" and to multiply the total in cell H4 by the value in cell I2 if G4 equals "TZZ." If it doesn't equal either, I want it just to stay as it is currently. Is this not possible because there is an XLOOKUP in that field currently? I've tried the following formulas and no luck, just getting errors.
=IF(G4="A4H",$H$1*H4,IF(G4="TZZ",$I$1*H4,H4)))
=IF(G4="A4H",$H$1*H4,IF(G4="TZZ",$I$1*H4,H4)))
=IF(G4="A4H",$H$1*XLOOKUP(A4,Census!C:C,Census!BT:BT),IF(G4="TZZ",$I$1*XLOOKUP(A4,Census!C:C,Census!BT:BT),XLOOKUP(A4,Census!C:C,Census!BT:BT)))))
Thank you so much in advance for your help!! Your amazing brain power is very much appreciated!
=IF(G4="A4H",$H$1*H4,IF(G4="TZZ",$I$1*H4,H4)))
=IF(G4="A4H",$H$1*H4,IF(G4="TZZ",$I$1*H4,H4)))
=IF(G4="A4H",$H$1*XLOOKUP(A4,Census!C:C,Census!BT:BT),IF(G4="TZZ",$I$1*XLOOKUP(A4,Census!C:C,Census!BT:BT),XLOOKUP(A4,Census!C:C,Census!BT:BT)))))
Thank you so much in advance for your help!! Your amazing brain power is very much appreciated!