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
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies