how to write this if statement correctly

[greg123]

Hi

I'm pretty sure I need an if statement but don't know how to work them.

Here is what I need to happen

In cell AC7 I need a sum
If F7 = greater than 1.49 then 1 if less than then 0 + If J7 = greater than 1.49 then 1 if less than then 0 + If P7 = greater than 1.49 then 1 if less than then 0 + If T7 = greater than 1.49 then 1 if less than then 0 + If X7 = greater than 1.49 then 1 if less than then 0

[greg123]

Also need it to come up blank if the total is zero

[Phuocam]

=IF(MAX(F7,J7,P7,X7)>1.49,1,0)

[lcartwright]

A bit long winded but:

=IF(F7>1.49,1,0)+IF(J7>1.49,1,0)+IF(T7>1.49,1,0)+IF(X7>1.49,1,0)

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )

[greg123]

Change made,

Thanks lcartwright that is what I needed.