Hi all
can somebody please assist with the following formula
=IF(F4<22, F4*8.7,F4*7/2) goes to f4*7/2 if 22 else multipliesf4*8
can i express more than one figure like the one above which calculates a different sum if the criteria 22 is met,can there be multiples to perform different calculations with more figures like 22as an example
thanks
john
Last edited by VBA Noob; 11-23-2008 at 05:45 AM.
G'day
Does this help ????????
Please Login or Register to view this content.
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
yeah cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks