Simple IF, IFS question

[John1953]

I have a simple problem where I have entered this formula; =IFS(G4="","",AU4="F&F",0),IF(G7<=5,5,G7*1.25)
.
All I get is a #VALUE! Return. G7 is a measurement like 4 1/2, The first two IF statements work fine, and second IF statement will work on its own. Thanks

 

[Peter_SSs]

Please try to get XL2BB going. It will get you much faster (& most likely better) solutions.

The conditions keep changing. Posts 1 & 6 say if F&F return 0, post 8 says if F&F return N/C, post 10 again shows if F&F 0.

Also, I do not like the IFS() function. When using that function, every condition has to be evaluated, even if it is not needed. I prefer nested IF functions which stop evaluating as soon as one of them returns TRUE. So see if this helps.

24 01 05.xlsm
	B	C	D	E	F	G	H
4	5.1	F&F		1.25	5	2	0
5	5.1			1.25	5	2	6.375
6				1.25	5	2
7	5.1			1.25	5	2	6.375
8	4			6	5	2	5
9	10		SERRATED	1.25	5	2	20
John1953

Cell Formulas
Range	Formula
H4:H9	H4	=IF(B4="","",IF(C4="F&F",0,IF(D4="SERRATED",B4*G4,IF(B4<=5,F4,B4*E4))))

 

[John1953]

Peter_SSs

Thank You, your formula worked perfect, thanks for the advice on IF statements, and I will get XL2BB going ASAP.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.