HI, i am still learning some simple formulas, but have one that is not working and hopeing someone can help with it. below is the formula. Where or what do I need to change so it works?
=IF(MAPPED!AV2=2,IF(AK2<0,"Adjustment - Trail","Trail"),IF(OR(AK2<0,MAPPED!AV2=3),"Adjustment - Upfront","Upfront")IF(OR(AK2<0,MAPPED!AV2=4),"Adjustment - Upfront","Upfront"))
This was all ok until I added the If formula at the end. What I want to do is add to the below.
=IF(MAPPED!AV2=2,IF(AK2<0,"Adjustment - Trail","Trail"),IF(OR(AK2<0,MAPPED!AV2=3),"Adjustment - Upfront","Upfront")
I thought if I just add the below in if would work, but seem not too.
IF(OR(AK2<0,MAPPED!AV2=4),"Adjustment - Upfront","Upfront"))
what i want it to do is look up another tab called "mapped" an if cell in AV2=4, then I want it to be coming through as Upfront, and adjustment upfront if less than 0.
Thanks
=IF(MAPPED!AV2=2,IF(AK2<0,"Adjustment - Trail","Trail"),IF(OR(AK2<0,MAPPED!AV2=3),"Adjustment - Upfront","Upfront")IF(OR(AK2<0,MAPPED!AV2=4),"Adjustment - Upfront","Upfront"))
This was all ok until I added the If formula at the end. What I want to do is add to the below.
=IF(MAPPED!AV2=2,IF(AK2<0,"Adjustment - Trail","Trail"),IF(OR(AK2<0,MAPPED!AV2=3),"Adjustment - Upfront","Upfront")
I thought if I just add the below in if would work, but seem not too.
IF(OR(AK2<0,MAPPED!AV2=4),"Adjustment - Upfront","Upfront"))
what i want it to do is look up another tab called "mapped" an if cell in AV2=4, then I want it to be coming through as Upfront, and adjustment upfront if less than 0.
Thanks