Home

Which formula to use

spritchett
Occasional Visitor

I am trying to use the following formulas in the same cell so depending on which C-cell value, it will do the calculations. Anyone have any idea on how to go about this?

 

=IF(C2:C38=5551,E2*1.3270)

=IF(C2:C38=8742,E2*1.1180)

=IF(C2:C38=5645,E2*1.3095)

=IF(C2:C38=8810,E2*1.1170)

=IF(C2:C38=5606,E2*1.1304)

1 Reply

Hi

 

Build a lookup table and refer to it with VLOOKUP().

     55511,327
5645 4,55,89275 87421,18
     56451,3095
     88101,117
     5606

1,1304

 

=VLOOKUP(C2,$H$1:$I$5,2,FALSE)*$E$2
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies