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

 

[DanteAmor]

You could put the possible scenarios and the results you need in each scenario.

That way we can know what formula you need. Explain each case

 

[John1953]

Hope this is what you're asking;

=IFS(G4="","",AU4="F&F",0) - This works returning a blank if G4 is blank, and then checks AU4 to see if that cell contains “F&F” and returns 0 if it is true, (I also need it to return a blank if AU4 is empty).

The IF(G7<=5,5,G7*1.25) - Enters a value of $5.00 if the measurement in G7 is equal to or less than 5 inches, otherwise it returns the value of G7 times $1.25.

I’m missing what ever is needed to combine all this into one formula.

 

[John1953]

DanteAmor
One more thing, I need to add another argument where if cell Z4=”Serrated”, the formula will use $2.00 in stead of $1.25

 

[DanteAmor]

But what results do you expect in the combination of values.

You must understand that I do not see your data, so you must put here the examples of what you have in each cell and what you expect as a result in each case.

And a brief explanation of each case.

 

[John1953]

DanteAmor
Thanks for you patience with me on this. Is the following answer your question? Not sure how else to present my problem.

In cell T7, I am expecting a dollar amount by calculating G7 (a measurement like 4.5 inches) times $1.25), but if G7 is less than or equal to 5 inches, enter in T7 a value of $5.00, If G7 is blank then leave T7 blank.
If U7 has the text “F&F” then enter a value of $0.00, if U7 is blank then leave T7 blank.

If cell Z4 has the text ”Serrated” then I need the formula in T7 should calculate G7 (a measurement like 4.5 inches) times $2.00)

 

[Peter_SSs]

Not sure how else to present my problem

Show us some varied sample data and the expected results with XL2BB

 

[John1953]

Cell H4 is where I’m looking for an amount, based on the following conditions;

• If eighter B4 or C4 are blank, then H4 should stay blank.
• If C4 is equal to F&F then H4 should show N/C.
• If C4 is blank, then an amount of B4xE4 (5.1x$1.25), H4 should show the calculated dollar amount ($6.75).
• If B4 is less than 5, then H4 should show the amount in F4 ($5.00).
• If B4 is greater than or equal to 5, then an amount of B4xE4 (5.1x$1.25), H4 should show the calculated dollar amount ($6.75).
• If D4 is equal to SERRATED, then an amount of B4xG4 (5.1x$2.00), H4 should show the calculated dollar amount ($10.20).
  

 

[Peter_SSs]

That does not make sense to me. Your third point says if C4 is blank then H4 should show a calculated dollar amount.
However, in that circumstance H4 would already have been set to blank because of point 1.

Also, your sample shows one set of circumstances which is not much to go on. Couldn't you give 5-10 rows with varied circumstances, fill in the results manually and give explanation in relation to those varied rows? (Preferably with XL2BB then you will likely get more helpers since they would not have to manually type out the sample data to test)

 

[John1953]

Hope this makes more sense! Sorry I don't have XL2BB installed yet, I will look into that later.