IF Function?

[tomdss]

Hi all,

Back again as I missed a vital calculation required.

For an existing calculation cell which is =K4*L4/1000000
I need to add an IF function being IF the word 'Novaflex' is chosen in Cell B4 I require the m2 calculation to be taken as G4*G5/1000000.

Basically based on the choice in Cell B4 there is one item that requires sizing calculated from different cells.

Does this make sense?

Thanks as ever
Tom

[José Augusto]

Try this
=IF(B4="NovaFlex",K4*L4/1000000,G4*G5/1000000)

[Tony Valko]

Maybe this...

=IF(B4="Novaflex",G4*G5/1000000,K4*L4/1000000)

[tomdss]

Thank you both

[Tony Valko]

You're welcome!