Im trying to figure out how to this (Im a newbie)
If anyone have time to help me out it would be much appreciated.
A1 (i.e 180000)
A2 (i.e 190000)
A3 (if A1 > A 2, then subtract and show result)
(if A1< A 2, then 0, and in B3 write ‘Below limit’)
By reading some of the tutorials in the links section, it seems that I need to use the if-function, Im just still on a very basic skill-level.
Thanks for your time!
Try:
In A3
=MAX(0,A1-A2)
In B3
=IF(A3=0,"Below limit","")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In A3, =MAX(A1-A2,0). In B3, =IF(A1<A2,"Below limit","")
Life is about perseverance. Remember: today's mighty oak tree is just yesterday's nut that held its ground.
If you like a post, please rate it with the scales icon (top right).
If you feel really indebted, please consider a donation to charity, such as Feed the Children or Habitat for Humanity.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks