nSomnius

New Member
Joined
Nov 7, 2013
Messages
26
This formula is supposed to test if one cell value is less than another, if so, show nothing, if not, then do a percentage calculation and show that, what am i missing?

=IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100")))

Happy to share the spreadsheet if it helps, it's nothing personal.
Here's how it shows up in Excel:

https://www.dropbox.com/s/kgdl1dhj3z1bgfu/excel problem.jpg?dl=0

The one cell that can't change as I use the fill handle is AX7. As soon as I drag the formula down a column all I see is the formula in the resulting cells. Ideas?
Thanks for any help with this.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Re: Need some help with what I thought was a basic IF formula

=if(az2<$ax$7,"",ba2/az2*100)
 
Upvote 0
Re: Need some help with what I thought was a basic IF formula

quote marks are the cause of your problem
=IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100")))

=IF((AZ2<$AX$7),(""),((BA2/AZ2)*100))

removing brackets not required too..
=IF(AZ2<$AX$7,"",BA2/AZ2*100)
 
Upvote 0
Re: Need some help with what I thought was a basic IF formula

Much obliged everyone! All set now.
 
Upvote 0

Forum statistics

Threads
1,213,567
Messages
6,114,342
Members
448,570
Latest member
rik81h

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top